﻿if exists (select * from dbo.sysobjects where name = 'sp_Departments_GetById')	drop procedure [dbo].[sp_Departments_GetById]Go CREATE PROCEDURE dbo.sp_Departments_GetById	@dpID		intAS	SELECT * FROM [Departments] WHERE dpID = @dpIDGo 